Creating a parameter field for use in a query
A parameter field can be created while previewing a query in the Crystal SQL Designer.
- On the Edit menu in the Crystal SQL Designer, click Parameter Field.
The New dialog box appears.
- Enter the name you want to use to identify the parameter, then click OK.
The Parameter Field dialog box appears.
- Enter the following information in the fields provided:
- Prompting Text
Enter the text you want to appear when the program prompts you. - Value Type
Enter the data type of the parameter field. - Default Prompting Value
Enter the value you want the program to use if you do not supply a new value. - Browse Field
Use this drop-down list to specify a default field.
- Click OK.
The parameter field can now be used in your query.